www.gusucode.com > wxApp PHP版微信小程序CMS系统 v1.0PHP源码程序 > wxApp PHP版微信小程序CMS系统 v1.0/wxAppCMS_v1.0.0/wxAppCMS_v1.0.0/app/user/user.func.php
<?php
/**
* iCMS - i Content Management System
* Copyright (c) 2007-2017 iCMSdev.com. All rights reserved.
*
* @author icmsdev <master@icmsdev.com>
* @site https://www.icmsdev.com
* @licence https://www.icmsdev.com/LICENSE.html
*/
defined('iPHP') OR exit('What are you doing?');
class userFunc{
public static function user_cookie($vars=null){
return user::get_cookie();
}
public static function user_data($vars=null){
if($vars['cookie']){
return user::get_cookie();
}
$vars['uid'] OR iUI::warning('iCMS:user:data 标签出错! 缺少"uid"属性或"uid"值为空.');
$uid = $vars['uid'];
if($uid=='me'){
$uid = 0;
$auth = user::get_cookie();
$auth && $uid = user::$userid;
}
$user = (array)user::get($uid);
if(isset($user['uid'])){
$vars['data'] && $user['data']= (array)user::data($uid);
}else{
if($vars['data']){
$userdata = user::data($uid);
foreach ($user as $key => $value) {
$user[$key] = (array)$value;
$user[$key]['data'] = (array)$userdata[$key];
}
}
}
return $user;
}
public static function user_list($vars=null){
iMap::reset();
$maxperpage = isset($vars['row'])?(int)$vars['row']:"100";
$cache_time = isset($vars['time'])?(int)$vars['time']:"-1";
$where_sql = "WHERE `status`='1'";
isset($vars['userid'])&& $where_sql.=" AND `uid`='{$vars['userid']}'";
isset($vars['gid']) && $where_sql.= " AND `gid` ='{$vars['gid']}'";
isset($vars['type']) && $where_sql.= " AND `type` ='{$vars['type']}'";
if (isset($vars['pid']) && !isset($vars['pids'])) {
iSQL::$check_numeric = true;
$where_sql .= iSQL::in($vars['pid'], 'pid');
}
if(isset($vars['pid!'])){
iSQL::$check_numeric = true;
$where_sql.= iSQL::in($vars['pid!'],'pid','not');
}
if(isset($vars['pids']) && !isset($vars['pid'])){
iMap::init('prop',iCMS_APP_USER,'pid');
//$where_sql.= iMap::exists($vars['pid'],'`#iCMS@__user`.uid'); //map 表大的用exists
$map_where = iMap::where($vars['pids']);
}
$by=$vars['by']=="ASC"?"ASC":"DESC";
switch ($vars['orderby']) {
case "id": $order_sql =" ORDER BY `uid` $by"; break;
case "article": $order_sql =" ORDER BY `article` $by"; break;
case "comments":$order_sql =" ORDER BY `comments` $by"; break;
case "follow": $order_sql =" ORDER BY `follow` $by"; break;
case "fans": $order_sql =" ORDER BY `fans` $by"; break;
case "hits": $order_sql =" ORDER BY `hits` $by"; break;
case "hot": $order_sql =" ORDER BY `hits` $by"; break;
case "week": $order_sql =" ORDER BY `hits_week` $by";break;
case "month": $order_sql =" ORDER BY `hits_month` $by";break;
default:$order_sql=" ORDER BY `uid` $by";
}
if($map_where){
$map_sql = iSQL::select_map($map_where);
$where_sql = ",({$map_sql}) map {$where_sql} AND `uid` = map.`iid`";
}
$offset = (int)$vars['offset'];
if($vars['page']){
$total = iCMS::page_total_cache("SELECT count(*) FROM `#iCMS@__user` {$where_sql}",null,iCMS::$config['cache']['page_total']);
$multi = iUI::page(array('total'=>$total,'perpage'=>$maxperpage,'unit'=>iUI::lang('iCMS:page:sql'),'nowindex'=>$GLOBALS['page']));
$offset = $multi->offset;
iView::assign("user_list_total",$total);
}
$limit = "LIMIT {$offset},{$maxperpage}";
$hash = md5($where_sql.$order_sql.$limit);
if($map_sql || $offset){
if($vars['cache']){
$map_cache_name = iPHP_DEVICE.'/user_map/'.$hash;
$ids_array = iCache::get($map_cache_name);
}
if(empty($ids_array)){
$ids_array = iDB::all("SELECT `id` FROM `#iCMS@__user` {$where_sql} {$order_sql} {$limit}");
$vars['cache'] && iCache::set($map_cache_name,$ids_array,$cache_time);
}
$ids = iSQL::values($ids_array,'uid');
$ids = $ids?$ids:'0';
$where_sql = "WHERE `uid` IN({$ids})";
}
if($vars['cache']){
$cache_name = iPHP_DEVICE.'/user_list/'.$hash;
$resource = iCache::get($cache_name);
}
if(empty($resource)){
$resource = iDB::all("SELECT * FROM `#iCMS@__user` {$where_sql} {$order_sql} {$limit}");
if($vars['data']){
$uidArray = iSQL::values($resource,'uid','array',null);
$uidArray && $user_data = (array) user::data($uidArray);
}
if($resource)foreach ($resource as $key => $value) {
unset($value['password']);
$value['url'] = user::router($value['uid'],"url");
$value['urls'] = user::router($value['uid'],"urls");
$value+=user::info($value['uid'],$value['nickname'],$vars['size']);
$value['gender'] = $value['gender']?'male':'female';
if($vars['data'] && $user_data){
$value['data'] = (array)$user_data[$value['uid']];
}
$resource[$key] = $value;
}
$vars['cache'] && iCache::set($cache_name,$resource,$cache_time);
}
return $resource;
}
public static function user_category($vars=null){
$row = isset($vars['row'])?(int)$vars['row']:"10";
$where_sql = "WHERE `uid`='".(int)$vars['userid']."' ";
$where_sql.= " AND `appid`='".(int)$vars['appid']."'";
$rs = iDB::all("SELECT * FROM `#iCMS@__user_category` {$where_sql} ORDER BY `cid` ASC LIMIT $row");
$resource = array();
if($rs)foreach ($rs as $key => $value) {
if($value['appid']==iCMS_APP_ARTICLE){
$router ='uid:cid';
}else if($value['appid']==iCMS_APP_FAVORITE){
$router ='uid:fav:cid';
}
$value['url'] = iURL::router(array($router,array($value['uid'],$value['cid'])));
if(isset($vars['loop'])){
$resource[$key] = $value;
}else{
$resource[$value['cid']]=$value;
}
}
return $resource;
}
public static function user_follow($vars=null){
$maxperpage = isset($vars['row'])?(int)$vars['row']:"30";
if($vars['fuid']){
$where_sql = "WHERE `fuid`='".$vars['fuid']."'"; //fans
}else{
$where_sql = "WHERE `uid`='".$vars['userid']."'";//follow
}
$offset = 0;
$limit = "LIMIT {$maxperpage}";
if($vars['page']){
$total = iCMS::page_total_cache("SELECT count(*) FROM `#iCMS@__user_follow` {$where_sql}",null,iCMS::$config['cache']['page_total']);
$multi = iUI::page(array('total'=>$total,'perpage'=>$maxperpage,'unit'=>iUI::lang('iCMS:page:sql'),'nowindex'=>$GLOBALS['page']));
$offset = $multi->offset;
$limit = "LIMIT {$offset},{$maxperpage}";
iView::assign("user_follow_total",$total);
}
$hash = md5($where_sql.$limit);
if($vars['cache']){
$cache_name = iPHP_DEVICE.'/user_follow/'.$hash;
$resource = iCache::get($cache_name);
}
$resource = iDB::all("SELECT * FROM `#iCMS@__user_follow` {$where_sql} {$limit}");
if($vars['data']){
$uidArray = iSQL::values($resource,array('uid','fuid'),'array',null);
$uidArray && $user_data = (array) user::data($uidArray);
}
$vars['followed'] && $follow_data = user::follow($vars['followed'],'all');
if($resource)foreach ($resource as $key => $value) {
if($vars['fuid']){
$value['avatar'] = user::router($value['uid'],'avatar');
$value['url'] = user::router($value['uid'],'url');
}else{
$value['avatar'] = user::router($value['fuid'],'avatar');
$value['url'] = user::router($value['fuid'],'url');
$value['uid'] = $value['fuid'];
$value['name'] = $value['fname'];
}
if($vars['data'] && $user_data){
$value['data'] = (array)$user_data[$value['uid']];
}
$vars['followed'] && $value['followed'] = $follow_data[$value['uid']]?1:0;
$resource[$key] = $value;
}
//var_dump($rs);
return $resource;
}
public static function user_stat($vars=null){
}
}